DROP TABLE MEMBER;
DROP SEQUENCE MEMBER_NO_SEQ;

create SEQUENCE MEMBER_NO_SEQ
START WITH 1
MAXVALUE 999999999
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER;

CREATE TABLE MEMBER 
(ID NUMBER(20) NOT NULL PRIMARY KEY, 
NAME VARCHAR2(50) NOT NULL, 
PASSWORD VARCHAR2(50) NOT NULL
);

INSERT INTO member (ID, NAME, password) VALUES (MEMBER_NO_SEQ.NEXTVAL,'Lee', 'Lee')
